Search for: All records

Analytic workloads on terabyte data-sets are often run in the cloud, where application and storage servers are separate and connected via network. In order to saturate the storage bandwidth and to hide the long storage latency, such a solution requires an expensive server cluster with sufficient aggregate DRAM capacity and hardware threads. An alternative solution is to push the query computation into storage servers. In this paper we present an in-storage Analytics QUery Offloading MAchiNe (AQUOMAN) to “offload” most SQL operators, including multi-way joins, to SSDs. AQUOMAN executes Table Tasks, which apply a static dataflow graph of SQL operators to relational tables to produce an output table. Table Tasks use a streaming computation model, which allows AQUOMAN to process queries with a reasonable amount of DRAM for intermediate results. AQUOMAN is a general analytic query processor, which can be integrated in the database software stack transparently. We have built a prototype of AQUOMAN in FPGAs, and using TPC-H benchmarks on 1TB data sets, shown that a single instance of 1TB AQUOMAN disk, on average, can free up 70% CPU cycles and reduce DRAM usage by 60%. One way to visualize this saving is to think that if we run queries sequentially and ignore inter-query page cache reuse, MonetDB running on a 4-core, 16GB-DRAM machine with AQUOMAN augmented SSDs performs, on average, as well as a MonetDB running on a 32-core, 128GB-DRAM machine with standard SSDs. 

Abstract Ionic liquids (ILs) are proposed as potentially ideal electrolytes for use in electrical double layer capacitors. However, recent discoveries of long‐range electrostatic screening in ILs have revealed that this understanding of the electrical double layer in highly concentrated solutions is still incomplete. Through precise time‐dependent measurements of wide‐angle X‐ray scattering and surface forces, novel molecular insight into their electrical double layer is provided. An ultraslow evolution of the nanostructure of three imidazolium ILs is observed, which reflects the reorganization of the ions in confined and unconfined (bulk) states. The observed phase transformation in the bulk consists of the ILs ordering over at least 20 h, reflected in an expansion or contraction of the spacing between the ions organized in domains of ≈10 nm. This transformation justifies the evolution of the electrical double layer measured in force measurements. Subtle differences between the ILs arise from the intricate balance between electrostatic and non‐electrostatic interactions. This work reveals a new time scale of the evolution of the IL structure and offers a new perspective for understanding the electrical double layer in ILs, with implications on diverse areas of inquiry, such as energy storage, lubrication, as well as micro‐ and nanoelectronics devices.